kumraivarsha3345
New Member
Posts: 3
Status: Offline
Joined:
pm
| Oracle Database Data: Backup and Restore (28th Dec 22 at 6:15am UTC)
Information base reinforcement and reestablish with Prophet Recuperation Supervisor (RMAN) | | Peruse the article to realize what devices can help you back up or reestablish a lost Prophet Data set - taking USB Drive Recovery account both implicit utilities and outsider programming. Prophet Data set stores all records of a made data set in information documents. Notwithstanding all information being legitimately kept in tablespaces, truth be told it is the items in records on a PC's hard circle. For instance, each data set table is put away as lines in a particular information record. Frequently a specific information base can be recuperated simply by reestablishing its information records and bringing them into Prophet Data set.
Data set structure in Prophet Data set
Making a reinforcement duplicate of Prophet Data set
Documenting with the method for the working framework
Documenting and reestablishing with the apparatuses Commodity/Import
Reestablishing a lost data set in Prophet Data set
Questions and replies
Remarks
GO TO VIEWHow to Recuperate MySQL, MSSql and Prophet Information bases ⚕️👨💻🖥️
Instructions to Recuperate MySQL, MSSql and Prophet Information bases ⚕️👨💻🖥️
Data set structure in Prophet Data set
Over its work, Prophet Information base purposes a few gatherings of records which ought to be documented (upheld) for additional recuperation. They are as per the following:
Information and tablespace documents (*.DBF).
Names of information and tablespace documents as well as the ways to them can be seen with SQL In addition to by executing the accompanying question:
SELECT t.name "Tablespace", f.name "Datafile" FROM v$tablespace t, v$datafile f WHERE t.ts# = f.ts# Re
Because of such question, a nitty gritty report will be produced:
SQL Order Line
*.DBF records
Information base design documents (*.ora).
Prophet data set design records have the expansion *.ora and can be tracked down in this organizer:
C:\oraclexe\app\oracle\product\11.2.0\server\dbs
*.ora documents
Data set control records (*.DBF).
The most straightforward method for deciding the way to, and the names of control records is to find in the design document *.ORA the line control_files, where the control records utilized by this data set will be recorded.
Likewise, you ought to execute this question in SQL In addition to decide the names of, and ways to the control documents:
SELECT worth FROM v$parameter WHERE name = 'control_files';
SQL Order Line. SELECT worth FROM v$parameter WHERE name = 'control_files'
Exchanges log documents (*.LOG).
To gain proficiency with the names of online exchanges logs and ways to them, you ought to execute this question in SQL In addition to:
SELECT part FROM v$logfile;
Because of such question, an itemized report will be created:
SQL Order Line. SELECT part FROM v$logfile
To decide the ways to envelopes where file exchanges logs are put away, you ought to execute this question:
SELECT objective FROM v$archive_dest where status='VALID';
Because of such inquiry, a report will be produced:
SQL Order Line. SELECT objective FROM v$archive_dest where status='VALID'
Secret phrase documents (*.ora).
When in doubt, these are documents with the augmentation *.ora, their names starting with PWD images.
model: PWDXE.ora
Way C:\oraclexe\app\oracle\product\11.2.0\server\database
*.ora Secret key documents
In this way, to save, document or reinforcement a Prophet Data set record, duplicates of the previously mentioned gatherings of documents ought to be made, to be specific:
*.DBF - information records, tablespace documents and data set control documents. Their area:
C:\oraclexe\app\oracle\oradata\XE
*.ora - information base arrangement records and secret word documents.
Setup documents:
C:\oraclexe\app\oracle\product\11.2.0\server\dbs
Secret key documents (PW… ora):
C:\oraclexe\app\oracle\product\11.2.0\server\database
*.LOG - exchanges log records:
C:\oraclexe\app\oracle\fast_recovery_area\XE\ONLINELOG
where Хе is the data set name, for our situation.
Making a reinforcement duplicate of Prophet Information base
A data set reinforcement of Prophet Data set can be made in two ways:
With the method for the working framework.
With the underlying instruments of Prophet Application Express - Import/Commodity.
Chronicling with the method for the working framework
Documenting with the method for the working framework proposes manual replicating of all functioning data set records, for example,
Tablespace documents.
Control documents.
Exchanges log documents.
Arrangement records.
For this situation, the method involved with chronicling comprises is simple duplicating of the control records, tablespace documents, design records and filed exchanges log documents into a reinforcement registry or a reinforcement waiter. Documenting is performed with the halted information base, and clients can't work with it then, at that point.
To reestablish an information base harmed as a result of a disappointment, it ought to be halted, and reinforcement duplicates of working records and exchange logs ought to be kept in touch with their past area.
| |
|
:: 
:: 
:: 
:: 
