restore oracle database from rman backup with different name
restore oracle database from rman backup with different name
Alibabacloud.com offers a wide variety of articles about restore oracle database from rman backup with different name, easily find your restore oracle database from rman backup with different name information here online.
Here are just a few ways to introduce backup methodsBackup: Logical backup, cold backup, hot backupLogical backups are also known as import, export, which is the role of transferring data between different Oracle databasesPhysical backup
previous restore operation, try again, if there are still problems, then take a look at the following method. First, delete the database you want to restore (full data backup must have Oh, or you will have a cup), do not blame me Oh! Right-click on the database directory to
to the specified size. DBCC Shrinkfile does not shrink the file to a size less than the actual space used, for example, allocate space is 10M, actual space is 6M, and when the targetsize is 1 o'clock, the file shrinks to 6 m, and the file is not shrunk to 1M. To shrink a database, use the following command: DBCC shrinkdatabase (database name, percent) The percen
1 Backing up the database NORTHSJGo to server, go to SqlServer2005, select database NORTHSJ for backupFinally, on disk D where the SqlServer2005 server is located, there will be a northsj.bat file.2 Restoring a Database NORTHSJCopy the Nothsj.bat on the original server to the new computer,Open the SqlServer2005 you want to re
1. Create a database directory2. Copy the Pfile file from the original host and change the ORACLE_SIDVi. Bash_profilesource. Bash_profile3. Start data to Nomount status$ sqlplus/as sysdbasql> startup nomount pfile= ' pfile file absolute location '; ORACLE instance started. Sql> exit4. View the backup Controlfile list$/usr/openv/netbackup/bin/bplist-s
Objective: To clone the library with Rman on the same machine
Environment: RedHat 4 + Oracle 10g
Master Library Name: DB01
Clone Library Name: Clonedb
1, the main library db01, with Rman for backup (datafile, controlfile, Arch
One, backup operations
Standby set
1. Set up a backup tag
Backup Database tag= ' full_bak1′;
Note: Each tag must be unique, and the same token can be used for multiple backups to restore only the most recent backup.
2. Set th
, and ORACLE_SID is an environment variable for the operating system. In the database connection process, ORACLE_SID must be consistent with the value of instance_name, otherwise error: Under UNIX: Oracle not available Win under: TNS: Protocol Adapter error The database instance name is also the
The new 10g ASM production database is coming soon. The following is a simple Backup recovery test before the release:1. perform backup first
$ Rman target/@ full_bak. SQL
Recovery Manager: Release 10.1.0.3.0-64bit Production
Copyright (c) 1995,200 4, Oracle. All rights rese
) "Full" incremental export (complete)//back up the entire database$ exp user/pwd file=/dir/xxx.dmp Log=xxx.log inctype=complete(2) "incremental" incremental export exports the data that was changed after the last backup.$ exp user/pwd file=/dir/xxx.dmp Log=xxx.log inctype=incremental(3) "Cumulative" incremental export (cumulative) Only exports changes in the database
we have deleted the two tables, we can demonstrate the use of a cumulative incremental backup to recover the two tables, and then observe the process of cumulative incremental recovery:2.2 Cumulative Incremental RecoveryTo see if the table has been restored:3 differences between the twoVariance Increment:Cumulative increment:From the above experiment, differential incremental and cumulative incremental backups are not significantly
Oracle dmp file Import (restore) to different table spaces and different usersFirst, Exp/imp solution:1, can use SED to modify the DMP file, normal importSed-i ' s/test_ts/users/g ' a.dmp2. The DMP file contains information about the table space when it was exported, and the table space does not exist if the correspond
backup and restore1, all database backups
The code is as follows
Copy Code
# Innobackupex--DEFAULTS-FILE=/ETC/MY.CNF--user=root/home/tank/backup/If you report the following error:InnoDB:Error:log file./ib_logfile0 is of different size 5242880 bytesInnodb:than specified in the. cnf file 503
selected.Sql> Select member from V$logfile;MEMBER----------------------------------------------------------------------------------------------------/u01/app/oracle/oradata/orcl01/redo03.log/u01/app/oracle/oradata/orcl01/redo02.log/u01/app/oracle/oradata/orcl01/redo01.logIn this case,/u01/app/oracle/oradata/orcl01 hav
Using T-SQL statement to realize the function of database backup and restore
Embodies four of the knowledge points in SQL Server:
1. Get the default directory on the SQL Server server
2. Use of Backup SQL statements
3. Restore the use of SQL statements while considering t
command: SET NEWNAMEExecuting command: SET NEWNAMEStart restore from month 1 to Month 12Use channel ORA_AUX_DISK_1Channel ORA_AUX_DISK_1: recovering the data file backup setChannel ORA_AUX_DISK_1: Specifies the data file to be recovered from the backup set.Restoring data file 00001 to/u01/app/oracle/oradata/dgc/system
the latest transaction processing. The restored block is generated throughout the process. This is called roll-forward or cache restoration.
3. At this time, the restored data file contains submitted and uncommitted changes.
4. Restore blocks are used to roll back any uncommitted changes. It is also called transaction recovery.
5. At this time, the data file is in the restored State and consistent with other data files in the
Regular oracle database backup and oracle Database Backup
Currently, we need to design a batch of processing files to achieve full backup on Monday, Incremental
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.